<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.17"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>Aestate: aestate/dbs/_mysql/__init__.py Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">Aestate
   &#160;<span id="projectnumber">1.0.5</span>
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.17 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div id="nav-path" class="navpath">
  <ul>
<li class="navelem"><a class="el" href="dir_374ee6e3281d8312d956f1f155302869.html">aestate</a></li><li class="navelem"><a class="el" href="dir_28e816ee5dbfc9bc7f7f6d0213c1e50c.html">dbs</a></li><li class="navelem"><a class="el" href="dir_854a7cd6cf997377b36cdb6a7f7d1ccb.html">_mysql</a></li>  </ul>
</div>
</div><!-- top -->
<div class="header">
  <div class="headertitle">
<div class="title">__init__.py</div>  </div>
</div><!--header-->
<div class="contents">
<a href="dbs_2__mysql_2____init_____8py.html">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno"><a class="line" href="namespaceaestate_1_1dbs_1_1__mysql.html">    1</a></span>&#160;<span class="keyword">import</span> copy</div>
<div class="line"><a name="l00002"></a><span class="lineno">    2</span>&#160;<span class="keyword">from</span> datetime <span class="keyword">import</span> datetime</div>
<div class="line"><a name="l00003"></a><span class="lineno">    3</span>&#160; </div>
<div class="line"><a name="l00004"></a><span class="lineno">    4</span>&#160;<span class="keyword">from</span> typing <span class="keyword">import</span> List, Tuple</div>
<div class="line"><a name="l00005"></a><span class="lineno">    5</span>&#160; </div>
<div class="line"><a name="l00006"></a><span class="lineno">    6</span>&#160;<span class="keyword">from</span> <a class="code" href="namespaceaestate_1_1dbs.html">aestate.dbs</a> <span class="keyword">import</span> base</div>
<div class="line"><a name="l00007"></a><span class="lineno">    7</span>&#160;<span class="keyword">from</span> <a class="code" href="namespaceaestate_1_1exception.html">aestate.exception</a> <span class="keyword">import</span> FieldNotExist</div>
<div class="line"><a name="l00008"></a><span class="lineno">    8</span>&#160;<span class="keyword">from</span> <a class="code" href="namespaceaestate_1_1dbs_1_1__mysql.html">aestate.dbs._mysql</a> <span class="keyword">import</span> tag</div>
<div class="line"><a name="l00009"></a><span class="lineno">    9</span>&#160;<span class="keyword">from</span> <a class="code" href="namespaceaestate_1_1util.html">aestate.util</a> <span class="keyword">import</span> others</div>
<div class="line"><a name="l00010"></a><span class="lineno">   10</span>&#160;<span class="keyword">from</span> <a class="code" href="namespaceaestate_1_1util_1_1_log.html">aestate.util.Log</a> <span class="keyword">import</span> ALog</div>
<div class="line"><a name="l00011"></a><span class="lineno">   11</span>&#160;<span class="keyword">import</span> threading</div>
<div class="line"><a name="l00012"></a><span class="lineno">   12</span>&#160;<span class="keyword">from</span> <a class="code" href="namespaceaestate_1_1work_1_1_modes.html">aestate.work.Modes</a> <span class="keyword">import</span> Singleton</div>
<div class="line"><a name="l00013"></a><span class="lineno">   13</span>&#160; </div>
<div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160; </div>
<div class="line"><a name="l00015"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html">   15</a></span>&#160;<span class="keyword">class </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html">ParseUtil</a>:</div>
<div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160; </div>
<div class="line"><a name="l00017"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a1659491b4d75d4ce96540f02bc2bea73">   17</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a1659491b4d75d4ce96540f02bc2bea73">parse_main</a>(self, *args, to_str=False, symbol=&#39;%s&#39;, left=&#39;`&#39;, right=&#39;`&#39;, **kwargs):</div>
<div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160;<span class="stringliteral">            解析属性:</span></div>
<div class="line"><a name="l00020"></a><span class="lineno">   20</span>&#160;<span class="stringliteral">                将属性格式设置为:[&#39;`a`,&#39;,&#39;`b`,&#39;,&#39;`c`&#39;]</span></div>
<div class="line"><a name="l00021"></a><span class="lineno">   21</span>&#160;<span class="stringliteral">            :param to_str:是否转成str格式</span></div>
<div class="line"><a name="l00022"></a><span class="lineno">   22</span>&#160;<span class="stringliteral">            :param args:参数</span></div>
<div class="line"><a name="l00023"></a><span class="lineno">   23</span>&#160;<span class="stringliteral">            :param symbol:分隔符语法</span></div>
<div class="line"><a name="l00024"></a><span class="lineno">   24</span>&#160;<span class="stringliteral">            :param left:分隔符语法</span></div>
<div class="line"><a name="l00025"></a><span class="lineno">   25</span>&#160;<span class="stringliteral">            :param right:分隔符语法</span></div>
<div class="line"><a name="l00026"></a><span class="lineno">   26</span>&#160;<span class="stringliteral">            :return:</span></div>
<div class="line"><a name="l00027"></a><span class="lineno">   27</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00028"></a><span class="lineno">   28</span>&#160; </div>
<div class="line"><a name="l00029"></a><span class="lineno">   29</span>&#160;        is_field = kwargs[<span class="stringliteral">&#39;is_field&#39;</span>] <span class="keywordflow">if</span> <span class="stringliteral">&#39;is_field&#39;</span> <span class="keywordflow">in</span> kwargs.keys() <span class="keywordflow">else</span> <span class="keyword">False</span></div>
<div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160; </div>
<div class="line"><a name="l00031"></a><span class="lineno">   31</span>&#160;        fields = []</div>
<div class="line"><a name="l00032"></a><span class="lineno">   32</span>&#160;        <span class="keywordflow">for</span> value <span class="keywordflow">in</span> args:</div>
<div class="line"><a name="l00033"></a><span class="lineno">   33</span>&#160;            value = others.conversion_types(value)</div>
<div class="line"><a name="l00034"></a><span class="lineno">   34</span>&#160;            <span class="keywordflow">if</span> to_str:</div>
<div class="line"><a name="l00035"></a><span class="lineno">   35</span>&#160;                <span class="keywordflow">if</span> is_field:</div>
<div class="line"><a name="l00036"></a><span class="lineno">   36</span>&#160;                    fields.append(f<span class="stringliteral">&#39;{left}{symbol}{right},&#39;</span> % (str(value)))</div>
<div class="line"><a name="l00037"></a><span class="lineno">   37</span>&#160;                <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00038"></a><span class="lineno">   38</span>&#160;                    fields.append(f<span class="stringliteral">&#39;{symbol},&#39;</span> % (str(value)))</div>
<div class="line"><a name="l00039"></a><span class="lineno">   39</span>&#160;            <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00040"></a><span class="lineno">   40</span>&#160;                fields.append(value <span class="keywordflow">if</span> <span class="keywordflow">not</span> ParseUtil.is_default(value) <span class="keywordflow">else</span> <span class="keywordtype">None</span>)</div>
<div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160;        <span class="keywordflow">if</span> len(fields) != 0:</div>
<div class="line"><a name="l00042"></a><span class="lineno">   42</span>&#160;            fields[len(fields) - 1] = fields[len(fields) - 1].replace(<span class="stringliteral">&#39;,&#39;</span>, <span class="stringliteral">&#39;&#39;</span>)</div>
<div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;            field_str = <span class="stringliteral">&#39;&#39;</span></div>
<div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160;            <span class="comment"># 转成字符串的话 &quot;`field1`,`field2`,`field3`&quot;</span></div>
<div class="line"><a name="l00045"></a><span class="lineno">   45</span>&#160;            <span class="keywordflow">if</span> to_str:</div>
<div class="line"><a name="l00046"></a><span class="lineno">   46</span>&#160;                <span class="keywordflow">for</span> field <span class="keywordflow">in</span> fields:</div>
<div class="line"><a name="l00047"></a><span class="lineno">   47</span>&#160;                    field_str += field</div>
<div class="line"><a name="l00048"></a><span class="lineno">   48</span>&#160;                <span class="keywordflow">return</span> field_str</div>
<div class="line"><a name="l00049"></a><span class="lineno">   49</span>&#160;            <span class="keywordflow">return</span> fields</div>
<div class="line"><a name="l00050"></a><span class="lineno">   50</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00051"></a><span class="lineno">   51</span>&#160;            <span class="keywordflow">return</span> <span class="keywordtype">None</span></div>
<div class="line"><a name="l00052"></a><span class="lineno">   52</span>&#160; </div>
<div class="line"><a name="l00053"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ae85305a9679051b479d80303b7a9b103">   53</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ae85305a9679051b479d80303b7a9b103">parse_key</a>(self, *args, **kwargs):</div>
<div class="line"><a name="l00054"></a><span class="lineno">   54</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00055"></a><span class="lineno">   55</span>&#160;<span class="stringliteral">        如果 is_field=True `field` [field]</span></div>
<div class="line"><a name="l00056"></a><span class="lineno">   56</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00057"></a><span class="lineno">   57</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00058"></a><span class="lineno">   58</span>&#160;<span class="stringliteral">        解析键格式,如:</span></div>
<div class="line"><a name="l00059"></a><span class="lineno">   59</span>&#160;<span class="stringliteral">            INSERT INTO `demo` (这里的就是键) VALUES (&#39;&#39;,&#39;&#39;,&#39;&#39;,&#39;&#39;);</span></div>
<div class="line"><a name="l00060"></a><span class="lineno">   60</span>&#160;<span class="stringliteral">        :param args:</span></div>
<div class="line"><a name="l00061"></a><span class="lineno">   61</span>&#160;<span class="stringliteral">        :return:</span></div>
<div class="line"><a name="l00062"></a><span class="lineno">   62</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00063"></a><span class="lineno">   63</span>&#160;        <span class="keywordflow">if</span> <span class="stringliteral">&#39;is_field&#39;</span> <span class="keywordflow">not</span> <span class="keywordflow">in</span> kwargs.keys():</div>
<div class="line"><a name="l00064"></a><span class="lineno">   64</span>&#160;            kwargs[<span class="stringliteral">&#39;is_field&#39;</span>] = <span class="keyword">True</span></div>
<div class="line"><a name="l00065"></a><span class="lineno">   65</span>&#160;        fields = self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a1659491b4d75d4ce96540f02bc2bea73">parse_main</a>(*args, to_str=<span class="keyword">True</span>, **kwargs)</div>
<div class="line"><a name="l00066"></a><span class="lineno">   66</span>&#160;        <span class="keywordflow">return</span> fields</div>
<div class="line"><a name="l00067"></a><span class="lineno">   67</span>&#160; </div>
<div class="line"><a name="l00068"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a5615e77e77754c370e71054b3e45d4eb">   68</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a5615e77e77754c370e71054b3e45d4eb">parse_update</a>(self, pojo, key):</div>
<div class="line"><a name="l00069"></a><span class="lineno">   69</span>&#160;        f = pojo.sqlFields</div>
<div class="line"><a name="l00070"></a><span class="lineno">   70</span>&#160;        kes = [f.update_str, f.left_subscript, pojo.__table_name__, f.right_subscript, f.set_str]</div>
<div class="line"><a name="l00071"></a><span class="lineno">   71</span>&#160;        params = []</div>
<div class="line"><a name="l00072"></a><span class="lineno">   72</span>&#160;        <span class="keywordflow">for</span> i <span class="keywordflow">in</span> pojo.fields:</div>
<div class="line"><a name="l00073"></a><span class="lineno">   73</span>&#160;            <span class="keywordflow">if</span> i != key <span class="keywordflow">and</span> <span class="keywordflow">not</span> pojo.getFields()[i].auto_time:</div>
<div class="line"><a name="l00074"></a><span class="lineno">   74</span>&#160;                kes.append(f<span class="stringliteral">&#39;`{i}`=%s&#39;</span>)</div>
<div class="line"><a name="l00075"></a><span class="lineno">   75</span>&#160;                kes.append(<span class="stringliteral">&quot;, &quot;</span>)</div>
<div class="line"><a name="l00076"></a><span class="lineno">   76</span>&#160;                <span class="keywordflow">if</span> pojo.getFields()[i].update_auto_time:</div>
<div class="line"><a name="l00077"></a><span class="lineno">   77</span>&#160;                    params.append(datetime.now())</div>
<div class="line"><a name="l00078"></a><span class="lineno">   78</span>&#160;                <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00079"></a><span class="lineno">   79</span>&#160;                    params.append(getattr(pojo, i))</div>
<div class="line"><a name="l00080"></a><span class="lineno">   80</span>&#160;        kes = kes[:-1]</div>
<div class="line"><a name="l00081"></a><span class="lineno">   81</span>&#160;        kes.append(f.where_str)</div>
<div class="line"><a name="l00082"></a><span class="lineno">   82</span>&#160;        kes.append(f<span class="stringliteral">&#39;`{key}`=%s&#39;</span>)</div>
<div class="line"><a name="l00083"></a><span class="lineno">   83</span>&#160;        params.append(getattr(pojo, key))</div>
<div class="line"><a name="l00084"></a><span class="lineno">   84</span>&#160;        sql = <span class="stringliteral">&#39;&#39;</span>.join(kes)</div>
<div class="line"><a name="l00085"></a><span class="lineno">   85</span>&#160;        <span class="keywordflow">return</span> sql, params</div>
<div class="line"><a name="l00086"></a><span class="lineno">   86</span>&#160; </div>
<div class="line"><a name="l00087"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a49c91d241a0f90a594b767b79f4747ff">   87</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a49c91d241a0f90a594b767b79f4747ff">parse_remove</a>(self, pojo, key):</div>
<div class="line"><a name="l00088"></a><span class="lineno">   88</span>&#160;        f = pojo.sqlFields</div>
<div class="line"><a name="l00089"></a><span class="lineno">   89</span>&#160;        kes = [f.delete_str, f.from_str, f.left_subscript, pojo.__table_name__, f.right_subscript, f.where_str]</div>
<div class="line"><a name="l00090"></a><span class="lineno">   90</span>&#160;        params = []</div>
<div class="line"><a name="l00091"></a><span class="lineno">   91</span>&#160;        kes.append(f<span class="stringliteral">&#39;`{key}`=%s&#39;</span>)</div>
<div class="line"><a name="l00092"></a><span class="lineno">   92</span>&#160;        params.append(getattr(pojo, key))</div>
<div class="line"><a name="l00093"></a><span class="lineno">   93</span>&#160;        sql = <span class="stringliteral">&#39;&#39;</span>.join(kes)</div>
<div class="line"><a name="l00094"></a><span class="lineno">   94</span>&#160;        <span class="keywordflow">return</span> sql, params</div>
<div class="line"><a name="l00095"></a><span class="lineno">   95</span>&#160; </div>
<div class="line"><a name="l00096"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ac3b4dd4b502ce4e358ad1ed77988383b">   96</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ac3b4dd4b502ce4e358ad1ed77988383b">parse_value</a>(self, *args, **kwargs):</div>
<div class="line"><a name="l00097"></a><span class="lineno">   97</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00098"></a><span class="lineno">   98</span>&#160;<span class="stringliteral">        解析值格式,如:</span></div>
<div class="line"><a name="l00099"></a><span class="lineno">   99</span>&#160;<span class="stringliteral">            INSERT INTO `demo` (`index`, `title`, `selects`, `success`) VALUES (这里的就是值);</span></div>
<div class="line"><a name="l00100"></a><span class="lineno">  100</span>&#160;<span class="stringliteral">        :param args:</span></div>
<div class="line"><a name="l00101"></a><span class="lineno">  101</span>&#160;<span class="stringliteral">        :return:</span></div>
<div class="line"><a name="l00102"></a><span class="lineno">  102</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00103"></a><span class="lineno">  103</span>&#160;        values = self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a1659491b4d75d4ce96540f02bc2bea73">parse_main</a>(*args, **kwargs)</div>
<div class="line"><a name="l00104"></a><span class="lineno">  104</span>&#160;        <span class="keywordflow">return</span> values</div>
<div class="line"><a name="l00105"></a><span class="lineno">  105</span>&#160; </div>
<div class="line"><a name="l00106"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#afaa381afb53a5a0b9f3e01cd286c299a">  106</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#afaa381afb53a5a0b9f3e01cd286c299a">parse_insert</a>(self, keys, values, __table_name__, insert_str, values_str, symbol=&#39;%s&#39;,</div>
<div class="line"><a name="l00107"></a><span class="lineno">  107</span>&#160;                     sql_format=&#39;%s %s (%s)%s(%s)<span class="stringliteral">&#39;):</span></div>
<div class="line"><a name="l00108"></a><span class="lineno">  108</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00109"></a><span class="lineno">  109</span>&#160;<span class="stringliteral">        实现此方法可自定义sql生成模式</span></div>
<div class="line"><a name="l00110"></a><span class="lineno">  110</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00111"></a><span class="lineno">  111</span>&#160;<span class="stringliteral">        keys:包含了所有需要解析的字段名</span></div>
<div class="line"><a name="l00112"></a><span class="lineno">  112</span>&#160;<span class="stringliteral">        values:包含了所有需要用到的字段的值</span></div>
<div class="line"><a name="l00113"></a><span class="lineno">  113</span>&#160;<span class="stringliteral">        __table_name__:表名称</span></div>
<div class="line"><a name="l00114"></a><span class="lineno">  114</span>&#160;<span class="stringliteral">        insert_str:insert的字符串</span></div>
<div class="line"><a name="l00115"></a><span class="lineno">  115</span>&#160;<span class="stringliteral">        values_str:values字符串</span></div>
<div class="line"><a name="l00116"></a><span class="lineno">  116</span>&#160;<span class="stringliteral">        symbol:格式化方式，以`%s`作为匿名符号</span></div>
<div class="line"><a name="l00117"></a><span class="lineno">  117</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00118"></a><span class="lineno">  118</span>&#160;        fields = self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ae85305a9679051b479d80303b7a9b103">parse_key</a>(*keys)</div>
<div class="line"><a name="l00119"></a><span class="lineno">  119</span>&#160;        values = self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ac3b4dd4b502ce4e358ad1ed77988383b">parse_value</a>(*values)</div>
<div class="line"><a name="l00120"></a><span class="lineno">  120</span>&#160;        <span class="comment"># 分析需要几个隐藏值</span></div>
<div class="line"><a name="l00121"></a><span class="lineno">  121</span>&#160;        hides_value = [f<span class="stringliteral">&#39;{symbol},&#39;</span> <span class="keywordflow">for</span> i <span class="keywordflow">in</span> range(len(values))]</div>
<div class="line"><a name="l00122"></a><span class="lineno">  122</span>&#160;        <span class="comment"># 去除末尾的逗号</span></div>
<div class="line"><a name="l00123"></a><span class="lineno">  123</span>&#160;        end = hides_value[len(hides_value) - 1]</div>
<div class="line"><a name="l00124"></a><span class="lineno">  124</span>&#160;        hides_value[len(hides_value) - 1] = end[0: len(end) - 1]</div>
<div class="line"><a name="l00125"></a><span class="lineno">  125</span>&#160;        <span class="comment"># 得到最后隐藏符号的字符串表达格式</span></div>
<div class="line"><a name="l00126"></a><span class="lineno">  126</span>&#160;        value = <span class="stringliteral">&#39;&#39;</span>.join(hides_value)</div>
<div class="line"><a name="l00127"></a><span class="lineno">  127</span>&#160;        sql = sql_format % (</div>
<div class="line"><a name="l00128"></a><span class="lineno">  128</span>&#160;            insert_str,</div>
<div class="line"><a name="l00129"></a><span class="lineno">  129</span>&#160;            str(__table_name__), fields, values_str, value</div>
<div class="line"><a name="l00130"></a><span class="lineno">  130</span>&#160;        )</div>
<div class="line"><a name="l00131"></a><span class="lineno">  131</span>&#160; </div>
<div class="line"><a name="l00132"></a><span class="lineno">  132</span>&#160;        kes = {<span class="stringliteral">&#39;sql&#39;</span>: sql}</div>
<div class="line"><a name="l00133"></a><span class="lineno">  133</span>&#160;        args = []</div>
<div class="line"><a name="l00134"></a><span class="lineno">  134</span>&#160;        [args.append(i) <span class="keywordflow">for</span> i <span class="keywordflow">in</span> values]</div>
<div class="line"><a name="l00135"></a><span class="lineno">  135</span>&#160;        kes[<span class="stringliteral">&#39;params&#39;</span>] = args</div>
<div class="line"><a name="l00136"></a><span class="lineno">  136</span>&#160;        <span class="keywordflow">return</span> kes</div>
<div class="line"><a name="l00137"></a><span class="lineno">  137</span>&#160; </div>
<div class="line"><a name="l00138"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ae0d8e6fa65b38eed4dd4b6ba93a56c9e">  138</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ae0d8e6fa65b38eed4dd4b6ba93a56c9e">parse_insert_pojo</a>(self, pojo, __table_name__, insert_str, values_str):</div>
<div class="line"><a name="l00139"></a><span class="lineno">  139</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00140"></a><span class="lineno">  140</span>&#160;<span class="stringliteral">        解析插入语句</span></div>
<div class="line"><a name="l00141"></a><span class="lineno">  141</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00142"></a><span class="lineno">  142</span>&#160;<span class="stringliteral">        INSERT INTO `__table_name__`(`title`,&#39;selects&#39;) VALUE (&#39;&#39;,&#39;&#39;)</span></div>
<div class="line"><a name="l00143"></a><span class="lineno">  143</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00144"></a><span class="lineno">  144</span>&#160;<span class="stringliteral">        :param pojo:POJO对象</span></div>
<div class="line"><a name="l00145"></a><span class="lineno">  145</span>&#160;<span class="stringliteral">        :param __table_name__:表名</span></div>
<div class="line"><a name="l00146"></a><span class="lineno">  146</span>&#160;<span class="stringliteral">        :param insert_str:insert的sql方言</span></div>
<div class="line"><a name="l00147"></a><span class="lineno">  147</span>&#160;<span class="stringliteral">        :param values_str:values的sql方言</span></div>
<div class="line"><a name="l00148"></a><span class="lineno">  148</span>&#160;<span class="stringliteral">        :return:</span></div>
<div class="line"><a name="l00149"></a><span class="lineno">  149</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00150"></a><span class="lineno">  150</span>&#160;        <span class="comment"># 得到所有的键</span></div>
<div class="line"><a name="l00151"></a><span class="lineno">  151</span>&#160;        ParseUtil.fieldExist(pojo, <span class="stringliteral">&#39;fields&#39;</span>, raise_exception=<span class="keyword">True</span>)</div>
<div class="line"><a name="l00152"></a><span class="lineno">  152</span>&#160;        <span class="comment"># 在得到值之后解析是否为空并删除为空的值和对应的字段</span></div>
<div class="line"><a name="l00153"></a><span class="lineno">  153</span>&#160;        cp_value = []</div>
<div class="line"><a name="l00154"></a><span class="lineno">  154</span>&#160;        <span class="comment"># 复制新的一张字段信息</span></div>
<div class="line"><a name="l00155"></a><span class="lineno">  155</span>&#160;        keys_copy = []</div>
<div class="line"><a name="l00156"></a><span class="lineno">  156</span>&#160; </div>
<div class="line"><a name="l00157"></a><span class="lineno">  157</span>&#160;        keys_c, cp_v = ParseUtil.parse_pojo(pojo)</div>
<div class="line"><a name="l00158"></a><span class="lineno">  158</span>&#160;        keys_copy += keys_c</div>
<div class="line"><a name="l00159"></a><span class="lineno">  159</span>&#160;        cp_value += cp_v</div>
<div class="line"><a name="l00160"></a><span class="lineno">  160</span>&#160; </div>
<div class="line"><a name="l00161"></a><span class="lineno">  161</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#afaa381afb53a5a0b9f3e01cd286c299a">parse_insert</a>(keys_copy, cp_value, __table_name__, insert_str=insert_str,</div>
<div class="line"><a name="l00162"></a><span class="lineno">  162</span>&#160;                                 values_str=values_str)</div>
<div class="line"><a name="l00163"></a><span class="lineno">  163</span>&#160; </div>
<div class="line"><a name="l00164"></a><span class="lineno">  164</span>&#160;    @staticmethod</div>
<div class="line"><a name="l00165"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ae8f0cf30f05102843b8e2d25c85e5c1d">  165</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ae8f0cf30f05102843b8e2d25c85e5c1d">parse_pojo</a>(pojo) -&gt; Tuple[list, list]:</div>
<div class="line"><a name="l00166"></a><span class="lineno">  166</span>&#160;        keys = pojo.fields</div>
<div class="line"><a name="l00167"></a><span class="lineno">  167</span>&#160;        <span class="comment"># 在得到值之后解析是否为空并删除为空的值和对应的字段</span></div>
<div class="line"><a name="l00168"></a><span class="lineno">  168</span>&#160;        cp_value = []</div>
<div class="line"><a name="l00169"></a><span class="lineno">  169</span>&#160;        <span class="comment"># 复制新的一张字段信息</span></div>
<div class="line"><a name="l00170"></a><span class="lineno">  170</span>&#160;        keys_copy = []</div>
<div class="line"><a name="l00171"></a><span class="lineno">  171</span>&#160;        values = [getattr(pojo, v) <span class="keywordflow">for</span> v <span class="keywordflow">in</span> keys]</div>
<div class="line"><a name="l00172"></a><span class="lineno">  172</span>&#160;        <span class="keywordflow">for</span> i, j <span class="keywordflow">in</span> enumerate(values):</div>
<div class="line"><a name="l00173"></a><span class="lineno">  173</span>&#160;            <span class="keywordflow">if</span> j <span class="keywordflow">is</span> <span class="keywordflow">not</span> <span class="keywordtype">None</span> <span class="keywordflow">and</span> <span class="keywordflow">not</span> ParseUtil.is_default(j):</div>
<div class="line"><a name="l00174"></a><span class="lineno">  174</span>&#160;                keys_copy.append(keys[i])</div>
<div class="line"><a name="l00175"></a><span class="lineno">  175</span>&#160;                cp_value.append(j)</div>
<div class="line"><a name="l00176"></a><span class="lineno">  176</span>&#160; </div>
<div class="line"><a name="l00177"></a><span class="lineno">  177</span>&#160;        <span class="keywordflow">return</span> keys_copy, cp_value</div>
<div class="line"><a name="l00178"></a><span class="lineno">  178</span>&#160; </div>
<div class="line"><a name="l00179"></a><span class="lineno">  179</span>&#160;    @staticmethod</div>
<div class="line"><a name="l00180"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a17ed4dfab84ad61174e1edb9969ea2ec">  180</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a17ed4dfab84ad61174e1edb9969ea2ec">parse_obj</a>(data: dict, instance: object) -&gt; object:</div>
<div class="line"><a name="l00181"></a><span class="lineno">  181</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00182"></a><span class="lineno">  182</span>&#160;<span class="stringliteral">        将数据解析成对象</span></div>
<div class="line"><a name="l00183"></a><span class="lineno">  183</span>&#160;<span class="stringliteral">        注意事项:</span></div>
<div class="line"><a name="l00184"></a><span class="lineno">  184</span>&#160;<span class="stringliteral">            数据来源必须是DbUtil下查询出来的</span></div>
<div class="line"><a name="l00185"></a><span class="lineno">  185</span>&#160;<span class="stringliteral">        :param data:单行数据</span></div>
<div class="line"><a name="l00186"></a><span class="lineno">  186</span>&#160;<span class="stringliteral">        :param instance:参与解析的对象</span></div>
<div class="line"><a name="l00187"></a><span class="lineno">  187</span>&#160;<span class="stringliteral">        :return:POJO对象</span></div>
<div class="line"><a name="l00188"></a><span class="lineno">  188</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00189"></a><span class="lineno">  189</span>&#160;        <span class="comment"># 深度复制对象</span></div>
<div class="line"><a name="l00190"></a><span class="lineno">  190</span>&#160;        part_obj = copy.copy(instance)</div>
<div class="line"><a name="l00191"></a><span class="lineno">  191</span>&#160;        <span class="keywordflow">for</span> key, value <span class="keywordflow">in</span> data.items():</div>
<div class="line"><a name="l00192"></a><span class="lineno">  192</span>&#160;            setattr(part_obj, key, value)</div>
<div class="line"><a name="l00193"></a><span class="lineno">  193</span>&#160;        <span class="keywordflow">return</span> part_obj</div>
<div class="line"><a name="l00194"></a><span class="lineno">  194</span>&#160; </div>
<div class="line"><a name="l00195"></a><span class="lineno">  195</span>&#160;    @staticmethod</div>
<div class="line"><a name="l00196"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#aa2923ad8dc9fc2e274bc29674f5e01ac">  196</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#aa2923ad8dc9fc2e274bc29674f5e01ac">find_last_id</a>(**kwargs):</div>
<div class="line"><a name="l00197"></a><span class="lineno">  197</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;作者:CACode 最后编辑于2021/4/12</span></div>
<div class="line"><a name="l00198"></a><span class="lineno">  198</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00199"></a><span class="lineno">  199</span>&#160;<span class="stringliteral">        遵循规则：</span></div>
<div class="line"><a name="l00200"></a><span class="lineno">  200</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00201"></a><span class="lineno">  201</span>&#160;<span class="stringliteral">            内部&gt;配置文件</span></div>
<div class="line"><a name="l00202"></a><span class="lineno">  202</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00203"></a><span class="lineno">  203</span>&#160;<span class="stringliteral">        是否包含返回最后一行ID的配置</span></div>
<div class="line"><a name="l00204"></a><span class="lineno">  204</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00205"></a><span class="lineno">  205</span>&#160;<span class="stringliteral">        只存在于更新操做的方法内，如：</span></div>
<div class="line"><a name="l00206"></a><span class="lineno">  206</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00207"></a><span class="lineno">  207</span>&#160;<span class="stringliteral">            insert,</span></div>
<div class="line"><a name="l00208"></a><span class="lineno">  208</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00209"></a><span class="lineno">  209</span>&#160;<span class="stringliteral">            update,</span></div>
<div class="line"><a name="l00210"></a><span class="lineno">  210</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00211"></a><span class="lineno">  211</span>&#160;<span class="stringliteral">            delete</span></div>
<div class="line"><a name="l00212"></a><span class="lineno">  212</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00213"></a><span class="lineno">  213</span>&#160;<span class="stringliteral">         Attributes:</span></div>
<div class="line"><a name="l00214"></a><span class="lineno">  214</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00215"></a><span class="lineno">  215</span>&#160;<span class="stringliteral">             conf_obj:配置类</span></div>
<div class="line"><a name="l00216"></a><span class="lineno">  216</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00217"></a><span class="lineno">  217</span>&#160;        conf_obj = kwargs[<span class="stringliteral">&#39;config_obj&#39;</span>]</div>
<div class="line"><a name="l00218"></a><span class="lineno">  218</span>&#160;        <span class="keywordflow">if</span> <span class="stringliteral">&#39;last_id&#39;</span> <span class="keywordflow">not</span> <span class="keywordflow">in</span> kwargs.keys():</div>
<div class="line"><a name="l00219"></a><span class="lineno">  219</span>&#160;            c_dict = conf_obj.get_dict()</div>
<div class="line"><a name="l00220"></a><span class="lineno">  220</span>&#160;            <span class="keywordflow">if</span> <span class="stringliteral">&#39;last_id&#39;</span> <span class="keywordflow">in</span> c_dict.keys():</div>
<div class="line"><a name="l00221"></a><span class="lineno">  221</span>&#160;                kwargs[<span class="stringliteral">&#39;last_id&#39;</span>] = c_dict[<span class="stringliteral">&#39;last_id&#39;</span>]</div>
<div class="line"><a name="l00222"></a><span class="lineno">  222</span>&#160;            <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00223"></a><span class="lineno">  223</span>&#160;                kwargs[<span class="stringliteral">&#39;last_id&#39;</span>] = <span class="keyword">False</span></div>
<div class="line"><a name="l00224"></a><span class="lineno">  224</span>&#160;        <span class="keywordflow">return</span> kwargs</div>
<div class="line"><a name="l00225"></a><span class="lineno">  225</span>&#160; </div>
<div class="line"><a name="l00226"></a><span class="lineno">  226</span>&#160;    @staticmethod</div>
<div class="line"><a name="l00227"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#afb3b666e0b3ab89d946dc04597c9ce58">  227</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#afb3b666e0b3ab89d946dc04597c9ce58">find_print_sql</a>(**kwargs):</div>
<div class="line"><a name="l00228"></a><span class="lineno">  228</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00229"></a><span class="lineno">  229</span>&#160;<span class="stringliteral">        遵循规则：</span></div>
<div class="line"><a name="l00230"></a><span class="lineno">  230</span>&#160;<span class="stringliteral">            内部&gt;配置文件</span></div>
<div class="line"><a name="l00231"></a><span class="lineno">  231</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00232"></a><span class="lineno">  232</span>&#160;<span class="stringliteral">        是否包含打印sql的配置</span></div>
<div class="line"><a name="l00233"></a><span class="lineno">  233</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00234"></a><span class="lineno">  234</span>&#160;<span class="stringliteral">        存在于所有数据库操做</span></div>
<div class="line"><a name="l00235"></a><span class="lineno">  235</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00236"></a><span class="lineno">  236</span>&#160;<span class="stringliteral">        Attributes:</span></div>
<div class="line"><a name="l00237"></a><span class="lineno">  237</span>&#160;<span class="stringliteral">             conf_obj:配置类</span></div>
<div class="line"><a name="l00238"></a><span class="lineno">  238</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00239"></a><span class="lineno">  239</span>&#160;        conf_obj = kwargs[<span class="stringliteral">&#39;config_obj&#39;</span>]</div>
<div class="line"><a name="l00240"></a><span class="lineno">  240</span>&#160;        <span class="keywordflow">if</span> <span class="stringliteral">&#39;print_sql&#39;</span> <span class="keywordflow">not</span> <span class="keywordflow">in</span> kwargs.keys():</div>
<div class="line"><a name="l00241"></a><span class="lineno">  241</span>&#160;            c_dict = conf_obj.get_dict()</div>
<div class="line"><a name="l00242"></a><span class="lineno">  242</span>&#160;            <span class="keywordflow">if</span> <span class="stringliteral">&#39;print_sql&#39;</span> <span class="keywordflow">in</span> c_dict.keys():</div>
<div class="line"><a name="l00243"></a><span class="lineno">  243</span>&#160;                kwargs[<span class="stringliteral">&#39;print_sql&#39;</span>] = c_dict[<span class="stringliteral">&#39;print_sql&#39;</span>]</div>
<div class="line"><a name="l00244"></a><span class="lineno">  244</span>&#160;            <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00245"></a><span class="lineno">  245</span>&#160;                kwargs[<span class="stringliteral">&#39;print_sql&#39;</span>] = <span class="keyword">False</span></div>
<div class="line"><a name="l00246"></a><span class="lineno">  246</span>&#160;        <span class="keywordflow">return</span> kwargs</div>
<div class="line"><a name="l00247"></a><span class="lineno">  247</span>&#160; </div>
<div class="line"><a name="l00248"></a><span class="lineno">  248</span>&#160;    @staticmethod</div>
<div class="line"><a name="l00249"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#adf50b29089db27341b0bf4b9b8a95016">  249</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#adf50b29089db27341b0bf4b9b8a95016">case_name</a>(text, rep_text=&#39;_&#39;, lower=True, upper=False):</div>
<div class="line"><a name="l00250"></a><span class="lineno">  250</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00251"></a><span class="lineno">  251</span>&#160;<span class="stringliteral">        将驼峰文本改为使用指定符号分割的字符串表达形式并全部小写</span></div>
<div class="line"><a name="l00252"></a><span class="lineno">  252</span>&#160;<span class="stringliteral">        :param text:需要替换的文本</span></div>
<div class="line"><a name="l00253"></a><span class="lineno">  253</span>&#160;<span class="stringliteral">        :param rep_text:在大写文本后面追加的字符串</span></div>
<div class="line"><a name="l00254"></a><span class="lineno">  254</span>&#160;<span class="stringliteral">        :param lower:是否需要全部小写</span></div>
<div class="line"><a name="l00255"></a><span class="lineno">  255</span>&#160;<span class="stringliteral">        :param upper:是否需要全部大写</span></div>
<div class="line"><a name="l00256"></a><span class="lineno">  256</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00257"></a><span class="lineno">  257</span>&#160;        lst = []</div>
<div class="line"><a name="l00258"></a><span class="lineno">  258</span>&#160;        <span class="keywordflow">for</span> index, char <span class="keywordflow">in</span> enumerate(text):</div>
<div class="line"><a name="l00259"></a><span class="lineno">  259</span>&#160;            <span class="keywordflow">if</span> char.isupper() <span class="keywordflow">and</span> index != 0:</div>
<div class="line"><a name="l00260"></a><span class="lineno">  260</span>&#160;                lst.append(rep_text)</div>
<div class="line"><a name="l00261"></a><span class="lineno">  261</span>&#160;            lst.append(char)</div>
<div class="line"><a name="l00262"></a><span class="lineno">  262</span>&#160;        <span class="comment"># 替换名称</span></div>
<div class="line"><a name="l00263"></a><span class="lineno">  263</span>&#160;        <span class="keywordflow">if</span> lower:</div>
<div class="line"><a name="l00264"></a><span class="lineno">  264</span>&#160;            <span class="keywordflow">return</span> <span class="stringliteral">&quot;&quot;</span>.join(lst).lower()</div>
<div class="line"><a name="l00265"></a><span class="lineno">  265</span>&#160;        <span class="keywordflow">elif</span> upper:</div>
<div class="line"><a name="l00266"></a><span class="lineno">  266</span>&#160;            <span class="keywordflow">return</span> <span class="stringliteral">&quot;&quot;</span>.join(lst).upper()</div>
<div class="line"><a name="l00267"></a><span class="lineno">  267</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00268"></a><span class="lineno">  268</span>&#160;            <span class="keywordflow">return</span> <span class="stringliteral">&quot;&quot;</span>.join(lst)</div>
<div class="line"><a name="l00269"></a><span class="lineno">  269</span>&#160; </div>
<div class="line"><a name="l00270"></a><span class="lineno">  270</span>&#160;    @staticmethod</div>
<div class="line"><a name="l00271"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ae1f4802c6dc78179f0b2fbad4a72739f">  271</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ae1f4802c6dc78179f0b2fbad4a72739f">is_default</a>(__val):</div>
<div class="line"><a name="l00272"></a><span class="lineno">  272</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00273"></a><span class="lineno">  273</span>&#160;<span class="stringliteral">        是否等于默认值</span></div>
<div class="line"><a name="l00274"></a><span class="lineno">  274</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00275"></a><span class="lineno">  275</span>&#160;        <span class="keywordflow">try</span>:</div>
<div class="line"><a name="l00276"></a><span class="lineno">  276</span>&#160;            t_v = __val.__class__.__base__</div>
<div class="line"><a name="l00277"></a><span class="lineno">  277</span>&#160;            <span class="keywordflow">if</span> t_v <span class="keywordflow">in</span> [<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1tag_1_1_template.html">tag.Template</a>, <a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1tag_1_1base_tag.html">tag.baseTag</a>]:</div>
<div class="line"><a name="l00278"></a><span class="lineno">  278</span>&#160;                <span class="keywordflow">return</span> __val.default <span class="keywordflow">is</span> <span class="keywordtype">None</span></div>
<div class="line"><a name="l00279"></a><span class="lineno">  279</span>&#160;        <span class="keywordflow">except</span> SyntaxError:</div>
<div class="line"><a name="l00280"></a><span class="lineno">  280</span>&#160;            <span class="keywordflow">return</span> <span class="keyword">False</span></div>
<div class="line"><a name="l00281"></a><span class="lineno">  281</span>&#160; </div>
<div class="line"><a name="l00282"></a><span class="lineno">  282</span>&#160;    @staticmethod</div>
<div class="line"><a name="l00283"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a1a040266609abb01fcbb3a47527283cf">  283</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a1a040266609abb01fcbb3a47527283cf">set_field</a>(obj, key, value):</div>
<div class="line"><a name="l00284"></a><span class="lineno">  284</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00285"></a><span class="lineno">  285</span>&#160;<span class="stringliteral">        当对象没有这个字段时，为对象设置一个字段</span></div>
<div class="line"><a name="l00286"></a><span class="lineno">  286</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00287"></a><span class="lineno">  287</span>&#160;<span class="stringliteral">        为了方便提高拓展性可解耦，框架内部务必使用此</span></div>
<div class="line"><a name="l00288"></a><span class="lineno">  288</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00289"></a><span class="lineno">  289</span>&#160;<span class="stringliteral">        方法或者set_field_compulsory()为操作管理类提供对象</span></div>
<div class="line"><a name="l00290"></a><span class="lineno">  290</span>&#160;<span class="stringliteral"></span> </div>
<div class="line"><a name="l00291"></a><span class="lineno">  291</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00292"></a><span class="lineno">  292</span>&#160;        <span class="keywordflow">if</span> <span class="keywordflow">not</span> hasattr(obj, key):</div>
<div class="line"><a name="l00293"></a><span class="lineno">  293</span>&#160;            setattr(obj, key, value)</div>
<div class="line"><a name="l00294"></a><span class="lineno">  294</span>&#160; </div>
<div class="line"><a name="l00295"></a><span class="lineno">  295</span>&#160;    @staticmethod</div>
<div class="line"><a name="l00296"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a3f318bacc1a79c2a0ea5810a1e07df52">  296</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a3f318bacc1a79c2a0ea5810a1e07df52">set_field_compulsory</a>(obj, key: str, data: dict, val: object) -&gt; <span class="keywordtype">None</span>:</div>
<div class="line"><a name="l00297"></a><span class="lineno">  297</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00298"></a><span class="lineno">  298</span>&#160;<span class="stringliteral">        如果键存在于data中，为obj插入该值，反之插入val</span></div>
<div class="line"><a name="l00299"></a><span class="lineno">  299</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00300"></a><span class="lineno">  300</span>&#160;        <span class="keywordflow">if</span> key <span class="keywordflow">in</span> data.keys():</div>
<div class="line"><a name="l00301"></a><span class="lineno">  301</span>&#160;            setattr(obj, key, data[key])</div>
<div class="line"><a name="l00302"></a><span class="lineno">  302</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00303"></a><span class="lineno">  303</span>&#160;            setattr(obj, key, val)</div>
<div class="line"><a name="l00304"></a><span class="lineno">  304</span>&#160; </div>
<div class="line"><a name="l00305"></a><span class="lineno">  305</span>&#160;    @staticmethod</div>
<div class="line"><a name="l00306"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a1ca5fcae7f8132f935ff3eb27448e736">  306</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a1ca5fcae7f8132f935ff3eb27448e736">fieldExist</a>(obj: object, field: str, el=<span class="keywordtype">None</span>, raise_exception=<span class="keyword">False</span>) -&gt; object:</div>
<div class="line"><a name="l00307"></a><span class="lineno">  307</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00308"></a><span class="lineno">  308</span>&#160;<span class="stringliteral">        在对象中获取一个字段的值,如果这个字段不存在,则将值设置为`el`</span></div>
<div class="line"><a name="l00309"></a><span class="lineno">  309</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00310"></a><span class="lineno">  310</span>&#160;        <span class="keywordflow">if</span> isinstance(obj, dict):</div>
<div class="line"><a name="l00311"></a><span class="lineno">  311</span>&#160;            <span class="keywordflow">if</span> field <span class="keywordflow">in</span> obj.keys():</div>
<div class="line"><a name="l00312"></a><span class="lineno">  312</span>&#160;                <span class="keywordflow">return</span> obj[field]</div>
<div class="line"><a name="l00313"></a><span class="lineno">  313</span>&#160;            <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00314"></a><span class="lineno">  314</span>&#160;                <span class="keywordflow">if</span> raise_exception:</div>
<div class="line"><a name="l00315"></a><span class="lineno">  315</span>&#160;                    <span class="keywordflow">raise</span> ALog.log_error(</div>
<div class="line"><a name="l00316"></a><span class="lineno">  316</span>&#160;                        msg=f<span class="stringliteral">&#39;the key of `{field}` cannot be found in the `{obj.__class__.__name__}`&#39;</span>,</div>
<div class="line"><a name="l00317"></a><span class="lineno">  317</span>&#160;                        obj=FieldNotExist,</div>
<div class="line"><a name="l00318"></a><span class="lineno">  318</span>&#160;                        raise_exception=<span class="keyword">True</span>)</div>
<div class="line"><a name="l00319"></a><span class="lineno">  319</span>&#160;                <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00320"></a><span class="lineno">  320</span>&#160;                    <span class="keywordflow">return</span> el</div>
<div class="line"><a name="l00321"></a><span class="lineno">  321</span>&#160;        <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00322"></a><span class="lineno">  322</span>&#160;            <span class="keywordflow">if</span> hasattr(obj, field):</div>
<div class="line"><a name="l00323"></a><span class="lineno">  323</span>&#160;                <span class="keywordflow">return</span> getattr(obj, field)</div>
<div class="line"><a name="l00324"></a><span class="lineno">  324</span>&#160;            <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00325"></a><span class="lineno">  325</span>&#160;                <span class="keywordflow">if</span> raise_exception:</div>
<div class="line"><a name="l00326"></a><span class="lineno">  326</span>&#160;                    <span class="keywordflow">raise</span> ALog.log_error(</div>
<div class="line"><a name="l00327"></a><span class="lineno">  327</span>&#160;                        msg=f<span class="stringliteral">&#39;the key of `{field}` cannot be found in the `{obj.__class__.__name__}`&#39;</span>,</div>
<div class="line"><a name="l00328"></a><span class="lineno">  328</span>&#160;                        obj=FieldNotExist,</div>
<div class="line"><a name="l00329"></a><span class="lineno">  329</span>&#160;                        raise_exception=<span class="keyword">True</span>)</div>
<div class="line"><a name="l00330"></a><span class="lineno">  330</span>&#160;                <span class="keywordflow">else</span>:</div>
<div class="line"><a name="l00331"></a><span class="lineno">  331</span>&#160;                    <span class="keywordflow">return</span> el</div>
<div class="line"><a name="l00332"></a><span class="lineno">  332</span>&#160; </div>
<div class="line"><a name="l00333"></a><span class="lineno">  333</span>&#160;    @staticmethod</div>
<div class="line"><a name="l00334"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ace50f38bba3c639dd0fdbac7a91dd3f4">  334</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ace50f38bba3c639dd0fdbac7a91dd3f4">parse_pojo_many</a>(pojo_many: list) -&gt; List[tuple]:</div>
<div class="line"><a name="l00335"></a><span class="lineno">  335</span>&#160; </div>
<div class="line"><a name="l00336"></a><span class="lineno">  336</span>&#160;        <span class="comment"># 在得到值之后解析是否为空并删除为空的值和对应的字段</span></div>
<div class="line"><a name="l00337"></a><span class="lineno">  337</span>&#160;        cp_value = []</div>
<div class="line"><a name="l00338"></a><span class="lineno">  338</span>&#160;        <span class="keywordflow">for</span> pojo <span class="keywordflow">in</span> pojo_many:</div>
<div class="line"><a name="l00339"></a><span class="lineno">  339</span>&#160;            keys_c, cp_v = ParseUtil.parse_pojo(pojo)</div>
<div class="line"><a name="l00340"></a><span class="lineno">  340</span>&#160;            cp_value.append(tuple(cp_v))</div>
<div class="line"><a name="l00341"></a><span class="lineno">  341</span>&#160;        <span class="comment"># 真实值</span></div>
<div class="line"><a name="l00342"></a><span class="lineno">  342</span>&#160;        <span class="keywordflow">return</span> cp_value</div>
<div class="line"><a name="l00343"></a><span class="lineno">  343</span>&#160; </div>
<div class="line"><a name="l00344"></a><span class="lineno">  344</span>&#160;    @staticmethod</div>
<div class="line"><a name="l00345"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a75311cf6ab0ef368af204b8551eeee8e">  345</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a75311cf6ab0ef368af204b8551eeee8e">insert_to_obj</a>(obj, kwargs):</div>
<div class="line"><a name="l00346"></a><span class="lineno">  346</span>&#160;        <span class="keywordflow">for</span> key, value <span class="keywordflow">in</span> kwargs.items():</div>
<div class="line"><a name="l00347"></a><span class="lineno">  347</span>&#160;            ParseUtil.set_field_compulsory(obj=obj, key=key, data=kwargs, val=value)</div>
<div class="line"><a name="l00348"></a><span class="lineno">  348</span>&#160; </div>
<div class="line"><a name="l00349"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a734ed2fd0f46ed39ff94bf41237005eb">  349</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a734ed2fd0f46ed39ff94bf41237005eb">get_pojo_sql</a>(self, instance):</div>
<div class="line"><a name="l00350"></a><span class="lineno">  350</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00351"></a><span class="lineno">  351</span>&#160;<span class="stringliteral">        获取创建pojo对象的sql语句</span></div>
<div class="line"><a name="l00352"></a><span class="lineno">  352</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00353"></a><span class="lineno">  353</span>&#160;        fields = instance.getFields()</div>
<div class="line"><a name="l00354"></a><span class="lineno">  354</span>&#160;        print(fields)</div>
<div class="line"><a name="l00355"></a><span class="lineno">  355</span>&#160; </div>
<div class="line"><a name="l00356"></a><span class="lineno">  356</span>&#160; </div>
<div class="line"><a name="l00357"></a><span class="lineno">  357</span>&#160;<span class="comment"># 所有常量以空格开头并且以空格结束</span></div>
<div class="line"><a name="l00358"></a><span class="lineno">  358</span>&#160;<span class="comment"># 空格符</span></div>
<div class="line"><a name="l00359"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html">  359</a></span>&#160;<span class="keyword">class </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html">Fields</a>:</div>
<div class="line"><a name="l00360"></a><span class="lineno">  360</span>&#160;    <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00361"></a><span class="lineno">  361</span>&#160;<span class="stringliteral">    默认的数据库方言配置</span></div>
<div class="line"><a name="l00362"></a><span class="lineno">  362</span>&#160;<span class="stringliteral">    &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00363"></a><span class="lineno">  363</span>&#160; </div>
<div class="line"><a name="l00364"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a7ce20b4284e58e0cf45bde5313a76b82">  364</a></span>&#160;    _instance_lock = threading.RLock()</div>
<div class="line"><a name="l00365"></a><span class="lineno">  365</span>&#160; </div>
<div class="line"><a name="l00366"></a><span class="lineno">  366</span>&#160;    @staticmethod</div>
<div class="line"><a name="l00367"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">  367</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(key: str) -&gt; str:</div>
<div class="line"><a name="l00368"></a><span class="lineno">  368</span>&#160;        <span class="keywordflow">return</span> f<span class="stringliteral">&#39; {key} &#39;</span></div>
<div class="line"><a name="l00369"></a><span class="lineno">  369</span>&#160; </div>
<div class="line"><a name="l00370"></a><span class="lineno">  370</span>&#160;    @property</div>
<div class="line"><a name="l00371"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#aa954b7c6dc8ec5be45afadaf96c782d1">  371</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#aa954b7c6dc8ec5be45afadaf96c782d1">left_subscript</a>(self):</div>
<div class="line"><a name="l00372"></a><span class="lineno">  372</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00373"></a><span class="lineno">  373</span>&#160;<span class="stringliteral">        左角标</span></div>
<div class="line"><a name="l00374"></a><span class="lineno">  374</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00375"></a><span class="lineno">  375</span>&#160;        <span class="keywordflow">return</span> <span class="stringliteral">&#39;`&#39;</span></div>
<div class="line"><a name="l00376"></a><span class="lineno">  376</span>&#160; </div>
<div class="line"><a name="l00377"></a><span class="lineno">  377</span>&#160;    @property</div>
<div class="line"><a name="l00378"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a39d43d7c7146306472dcf68a1d567711">  378</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a39d43d7c7146306472dcf68a1d567711">space</a>(self):</div>
<div class="line"><a name="l00379"></a><span class="lineno">  379</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00380"></a><span class="lineno">  380</span>&#160;<span class="stringliteral">        空格</span></div>
<div class="line"><a name="l00381"></a><span class="lineno">  381</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00382"></a><span class="lineno">  382</span>&#160;        <span class="keywordflow">return</span> <span class="stringliteral">&#39; &#39;</span></div>
<div class="line"><a name="l00383"></a><span class="lineno">  383</span>&#160; </div>
<div class="line"><a name="l00384"></a><span class="lineno">  384</span>&#160;    @property</div>
<div class="line"><a name="l00385"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a52d2b02229ebf64b80de220d5739785a">  385</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a52d2b02229ebf64b80de220d5739785a">right_subscript</a>(self):</div>
<div class="line"><a name="l00386"></a><span class="lineno">  386</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00387"></a><span class="lineno">  387</span>&#160;<span class="stringliteral">        右角标</span></div>
<div class="line"><a name="l00388"></a><span class="lineno">  388</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00389"></a><span class="lineno">  389</span>&#160;        <span class="keywordflow">return</span> <span class="stringliteral">&#39;`&#39;</span></div>
<div class="line"><a name="l00390"></a><span class="lineno">  390</span>&#160; </div>
<div class="line"><a name="l00391"></a><span class="lineno">  391</span>&#160;    @property</div>
<div class="line"><a name="l00392"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ae5a69b48039b53489a1fb72588482719">  392</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ae5a69b48039b53489a1fb72588482719">insert_str</a>(self):</div>
<div class="line"><a name="l00393"></a><span class="lineno">  393</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00394"></a><span class="lineno">  394</span>&#160;<span class="stringliteral">        插入</span></div>
<div class="line"><a name="l00395"></a><span class="lineno">  395</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00396"></a><span class="lineno">  396</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;INSERT INTO&#39;</span>)</div>
<div class="line"><a name="l00397"></a><span class="lineno">  397</span>&#160; </div>
<div class="line"><a name="l00398"></a><span class="lineno">  398</span>&#160;    @property</div>
<div class="line"><a name="l00399"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#afb883f03c0e5b31b7e8a10e7a04424de">  399</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#afb883f03c0e5b31b7e8a10e7a04424de">delete_str</a>(self):</div>
<div class="line"><a name="l00400"></a><span class="lineno">  400</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00401"></a><span class="lineno">  401</span>&#160;<span class="stringliteral">        删除</span></div>
<div class="line"><a name="l00402"></a><span class="lineno">  402</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00403"></a><span class="lineno">  403</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;DELETE&#39;</span>)</div>
<div class="line"><a name="l00404"></a><span class="lineno">  404</span>&#160; </div>
<div class="line"><a name="l00405"></a><span class="lineno">  405</span>&#160;    @property</div>
<div class="line"><a name="l00406"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a9cd9e8b40f0851764e691449a67e06ce">  406</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a9cd9e8b40f0851764e691449a67e06ce">update_str</a>(self):</div>
<div class="line"><a name="l00407"></a><span class="lineno">  407</span>&#160;        <span class="stringliteral">&quot;&quot;&quot;</span></div>
<div class="line"><a name="l00408"></a><span class="lineno">  408</span>&#160;<span class="stringliteral">        更新</span></div>
<div class="line"><a name="l00409"></a><span class="lineno">  409</span>&#160;<span class="stringliteral">        &quot;&quot;&quot;</span></div>
<div class="line"><a name="l00410"></a><span class="lineno">  410</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;UPDATE&#39;</span>)</div>
<div class="line"><a name="l00411"></a><span class="lineno">  411</span>&#160; </div>
<div class="line"><a name="l00412"></a><span class="lineno">  412</span>&#160;    @property</div>
<div class="line"><a name="l00413"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a5f1f67a3fe6e4c06dd7051ea8a320bbf">  413</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a5f1f67a3fe6e4c06dd7051ea8a320bbf">find_str</a>(self):</div>
<div class="line"><a name="l00414"></a><span class="lineno">  414</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;SELECT&#39;</span>)</div>
<div class="line"><a name="l00415"></a><span class="lineno">  415</span>&#160; </div>
<div class="line"><a name="l00416"></a><span class="lineno">  416</span>&#160;    @property</div>
<div class="line"><a name="l00417"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a08bf7945554d7e2627f961b09ab7c3f6">  417</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a08bf7945554d7e2627f961b09ab7c3f6">where_str</a>(self):</div>
<div class="line"><a name="l00418"></a><span class="lineno">  418</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;WHERE&#39;</span>)</div>
<div class="line"><a name="l00419"></a><span class="lineno">  419</span>&#160; </div>
<div class="line"><a name="l00420"></a><span class="lineno">  420</span>&#160;    @property</div>
<div class="line"><a name="l00421"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab6ceb33d4f9ca3ea8e5244c420623dab">  421</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab6ceb33d4f9ca3ea8e5244c420623dab">by_str</a>(self):</div>
<div class="line"><a name="l00422"></a><span class="lineno">  422</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;BY&#39;</span>)</div>
<div class="line"><a name="l00423"></a><span class="lineno">  423</span>&#160; </div>
<div class="line"><a name="l00424"></a><span class="lineno">  424</span>&#160;    @property</div>
<div class="line"><a name="l00425"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a2a2de8a1b2c0be73a7c0e09b3d22dbf3">  425</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a2a2de8a1b2c0be73a7c0e09b3d22dbf3">order_by_str</a>(self):</div>
<div class="line"><a name="l00426"></a><span class="lineno">  426</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;ORDER BY&#39;</span>)</div>
<div class="line"><a name="l00427"></a><span class="lineno">  427</span>&#160; </div>
<div class="line"><a name="l00428"></a><span class="lineno">  428</span>&#160;    @property</div>
<div class="line"><a name="l00429"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a6b4970ec555be4a06ed5c7e2c263efe4">  429</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a6b4970ec555be4a06ed5c7e2c263efe4">group_by_str</a>(self):</div>
<div class="line"><a name="l00430"></a><span class="lineno">  430</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;GROUP BY&#39;</span>)</div>
<div class="line"><a name="l00431"></a><span class="lineno">  431</span>&#160; </div>
<div class="line"><a name="l00432"></a><span class="lineno">  432</span>&#160;    @property</div>
<div class="line"><a name="l00433"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a7133146198a939dc7c5f5f38511387c5">  433</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a7133146198a939dc7c5f5f38511387c5">desc_str</a>(self):</div>
<div class="line"><a name="l00434"></a><span class="lineno">  434</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;DESC&#39;</span>)</div>
<div class="line"><a name="l00435"></a><span class="lineno">  435</span>&#160; </div>
<div class="line"><a name="l00436"></a><span class="lineno">  436</span>&#160;    @property</div>
<div class="line"><a name="l00437"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a7493eea273580951f8ce1a2fe73a3f30">  437</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a7493eea273580951f8ce1a2fe73a3f30">set_str</a>(self):</div>
<div class="line"><a name="l00438"></a><span class="lineno">  438</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;SET&#39;</span>)</div>
<div class="line"><a name="l00439"></a><span class="lineno">  439</span>&#160; </div>
<div class="line"><a name="l00440"></a><span class="lineno">  440</span>&#160;    @property</div>
<div class="line"><a name="l00441"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a0d58b3c09dc14f73832ded52e921e81b">  441</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a0d58b3c09dc14f73832ded52e921e81b">ander_str</a>(self):</div>
<div class="line"><a name="l00442"></a><span class="lineno">  442</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;AND&#39;</span>)</div>
<div class="line"><a name="l00443"></a><span class="lineno">  443</span>&#160; </div>
<div class="line"><a name="l00444"></a><span class="lineno">  444</span>&#160;    @property</div>
<div class="line"><a name="l00445"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a2dde140ca287b970b0befe8fde431b06">  445</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a2dde140ca287b970b0befe8fde431b06">limit_str</a>(self):</div>
<div class="line"><a name="l00446"></a><span class="lineno">  446</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;LIMIT&#39;</span>)</div>
<div class="line"><a name="l00447"></a><span class="lineno">  447</span>&#160; </div>
<div class="line"><a name="l00448"></a><span class="lineno">  448</span>&#160;    @property</div>
<div class="line"><a name="l00449"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a4367ca8070595df3332a4b48b8af926c">  449</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a4367ca8070595df3332a4b48b8af926c">from_str</a>(self):</div>
<div class="line"><a name="l00450"></a><span class="lineno">  450</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;FROM&#39;</span>)</div>
<div class="line"><a name="l00451"></a><span class="lineno">  451</span>&#160; </div>
<div class="line"><a name="l00452"></a><span class="lineno">  452</span>&#160;    @property</div>
<div class="line"><a name="l00453"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a5c1ec1013eb32813d9960e8d843fbe4e">  453</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a5c1ec1013eb32813d9960e8d843fbe4e">value_str</a>(self):</div>
<div class="line"><a name="l00454"></a><span class="lineno">  454</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;VALUE&#39;</span>)</div>
<div class="line"><a name="l00455"></a><span class="lineno">  455</span>&#160; </div>
<div class="line"><a name="l00456"></a><span class="lineno">  456</span>&#160;    @property</div>
<div class="line"><a name="l00457"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a3b8872efa64705ca6bca58bcee6d6b45">  457</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a3b8872efa64705ca6bca58bcee6d6b45">values_str</a>(self):</div>
<div class="line"><a name="l00458"></a><span class="lineno">  458</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;VALUES&#39;</span>)</div>
<div class="line"><a name="l00459"></a><span class="lineno">  459</span>&#160; </div>
<div class="line"><a name="l00460"></a><span class="lineno">  460</span>&#160;    @property</div>
<div class="line"><a name="l00461"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a049783a48d412908762e575970bd69e6">  461</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a049783a48d412908762e575970bd69e6">asses_str</a>(self):</div>
<div class="line"><a name="l00462"></a><span class="lineno">  462</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;AS&#39;</span>)</div>
<div class="line"><a name="l00463"></a><span class="lineno">  463</span>&#160; </div>
<div class="line"><a name="l00464"></a><span class="lineno">  464</span>&#160;    @property</div>
<div class="line"><a name="l00465"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a9aa2757979eb6d85b78d0c6ac52b79c9">  465</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a9aa2757979eb6d85b78d0c6ac52b79c9">left_par</a>(self):</div>
<div class="line"><a name="l00466"></a><span class="lineno">  466</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;(&#39;</span>)</div>
<div class="line"><a name="l00467"></a><span class="lineno">  467</span>&#160; </div>
<div class="line"><a name="l00468"></a><span class="lineno">  468</span>&#160;    @property</div>
<div class="line"><a name="l00469"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a9acc2223fb8aee96870aac942b1a8796">  469</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a9acc2223fb8aee96870aac942b1a8796">right_par</a>(self):</div>
<div class="line"><a name="l00470"></a><span class="lineno">  470</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;)&#39;</span>)</div>
<div class="line"><a name="l00471"></a><span class="lineno">  471</span>&#160; </div>
<div class="line"><a name="l00472"></a><span class="lineno">  472</span>&#160;    @property</div>
<div class="line"><a name="l00473"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ac9c4c272f28e485c7bd9630c98094687">  473</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ac9c4c272f28e485c7bd9630c98094687">comma</a>(self):</div>
<div class="line"><a name="l00474"></a><span class="lineno">  474</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;,&#39;</span>)</div>
<div class="line"><a name="l00475"></a><span class="lineno">  475</span>&#160; </div>
<div class="line"><a name="l00476"></a><span class="lineno">  476</span>&#160;    @property</div>
<div class="line"><a name="l00477"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ac8360186b23df53ce7366fe68b33c6b7">  477</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ac8360186b23df53ce7366fe68b33c6b7">eq</a>(self):</div>
<div class="line"><a name="l00478"></a><span class="lineno">  478</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;=&#39;</span>)</div>
<div class="line"><a name="l00479"></a><span class="lineno">  479</span>&#160; </div>
<div class="line"><a name="l00480"></a><span class="lineno">  480</span>&#160;    @property</div>
<div class="line"><a name="l00481"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a330bc1d69ac87922e2ed0c564ce71fce">  481</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a330bc1d69ac87922e2ed0c564ce71fce">on_str</a>(self):</div>
<div class="line"><a name="l00482"></a><span class="lineno">  482</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;on&#39;</span>)</div>
<div class="line"><a name="l00483"></a><span class="lineno">  483</span>&#160; </div>
<div class="line"><a name="l00484"></a><span class="lineno">  484</span>&#160;    @property</div>
<div class="line"><a name="l00485"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#afa5e92496e2f008ba6fd47e61ee3cae1">  485</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#afa5e92496e2f008ba6fd47e61ee3cae1">left_join_str</a>(self):</div>
<div class="line"><a name="l00486"></a><span class="lineno">  486</span>&#160;        <span class="keywordflow">return</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">parse_field</a>(<span class="stringliteral">&#39;LEFT JOIN&#39;</span>)</div>
<div class="line"><a name="l00487"></a><span class="lineno">  487</span>&#160; </div>
<div class="line"><a name="l00488"></a><span class="lineno">  488</span>&#160;    @property</div>
<div class="line"><a name="l00489"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a9e58cd803affd57b482ee7ee20425ad7">  489</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a9e58cd803affd57b482ee7ee20425ad7">symbol</a>(self):</div>
<div class="line"><a name="l00490"></a><span class="lineno">  490</span>&#160;        <span class="keywordflow">return</span> <span class="stringliteral">&#39;&gt;&gt; &lt;&lt; == &lt;= &gt;= != - + / * %&#39;</span>.split(<span class="stringliteral">&#39; &#39;</span>)</div>
<div class="line"><a name="l00491"></a><span class="lineno">  491</span>&#160; </div>
<div class="line"><a name="l00492"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a14965a4a1d4cb9299bf3f651222f4dfa">  492</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a14965a4a1d4cb9299bf3f651222f4dfa">__new__</a>(cls, *args, **kwargs):</div>
<div class="line"><a name="l00493"></a><span class="lineno">  493</span>&#160;        instance = Singleton.createObject(cls)</div>
<div class="line"><a name="l00494"></a><span class="lineno">  494</span>&#160;        <span class="keywordflow">return</span> instance</div>
<div class="line"><a name="l00495"></a><span class="lineno">  495</span>&#160; </div>
<div class="line"><a name="l00496"></a><span class="lineno">  496</span>&#160; </div>
<div class="line"><a name="l00497"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html">  497</a></span>&#160;<span class="keyword">class </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html">OperaBase</a>(<a class="code" href="classaestate_1_1dbs_1_1base_1_1_opera_base.html">base.OperaBase</a>):</div>
<div class="line"><a name="l00498"></a><span class="lineno">  498</span>&#160; </div>
<div class="line"><a name="l00499"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#af962700fdf116f30957cb512adc334eb">  499</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#af962700fdf116f30957cb512adc334eb">extra</a>(self, field) -&gt; Tuple[bool, object]:</div>
<div class="line"><a name="l00500"></a><span class="lineno">  500</span>&#160; </div>
<div class="line"><a name="l00501"></a><span class="lineno">  501</span>&#160;        ver = {</div>
<div class="line"><a name="l00502"></a><span class="lineno">  502</span>&#160;            <span class="stringliteral">&quot;Field&quot;</span>: <span class="keyword">lambda</span> x: x[<span class="stringliteral">&#39;Field&#39;</span>] == field.name,</div>
<div class="line"><a name="l00503"></a><span class="lineno">  503</span>&#160;            <span class="stringliteral">&quot;Type&quot;</span>:</div>
<div class="line"><a name="l00504"></a><span class="lineno">  504</span>&#160;                <span class="keyword">lambda</span> x: x[<span class="stringliteral">&quot;Type&quot;</span>] == field.t_type</div>
<div class="line"><a name="l00505"></a><span class="lineno">  505</span>&#160;                <span class="keywordflow">if</span> field.length <span class="keywordflow">is</span> <span class="keywordtype">None</span> <span class="keywordflow">else</span></div>
<div class="line"><a name="l00506"></a><span class="lineno">  506</span>&#160;                f<span class="stringliteral">&quot;{field.t_type}({field.length})&quot;</span></div>
<div class="line"><a name="l00507"></a><span class="lineno">  507</span>&#160;                <span class="keywordflow">if</span> field.d_point <span class="keywordflow">is</span> <span class="keywordtype">None</span> <span class="keywordflow">else</span></div>
<div class="line"><a name="l00508"></a><span class="lineno">  508</span>&#160;                f<span class="stringliteral">&quot;{field.t_type}({field.length},{field.d_point})&quot;</span>,</div>
<div class="line"><a name="l00509"></a><span class="lineno">  509</span>&#160; </div>
<div class="line"><a name="l00510"></a><span class="lineno">  510</span>&#160;            <span class="stringliteral">&quot;Null&quot;</span>: {</div>
<div class="line"><a name="l00511"></a><span class="lineno">  511</span>&#160; </div>
<div class="line"><a name="l00512"></a><span class="lineno">  512</span>&#160;            },</div>
<div class="line"><a name="l00513"></a><span class="lineno">  513</span>&#160;            <span class="stringliteral">&quot;Key&quot;</span>: {</div>
<div class="line"><a name="l00514"></a><span class="lineno">  514</span>&#160; </div>
<div class="line"><a name="l00515"></a><span class="lineno">  515</span>&#160;            },</div>
<div class="line"><a name="l00516"></a><span class="lineno">  516</span>&#160;            <span class="stringliteral">&quot;Default&quot;</span>: {</div>
<div class="line"><a name="l00517"></a><span class="lineno">  517</span>&#160; </div>
<div class="line"><a name="l00518"></a><span class="lineno">  518</span>&#160;            },</div>
<div class="line"><a name="l00519"></a><span class="lineno">  519</span>&#160;            <span class="stringliteral">&quot;Extra&quot;</span>: {</div>
<div class="line"><a name="l00520"></a><span class="lineno">  520</span>&#160; </div>
<div class="line"><a name="l00521"></a><span class="lineno">  521</span>&#160;            }</div>
<div class="line"><a name="l00522"></a><span class="lineno">  522</span>&#160;        }</div>
<div class="line"><a name="l00523"></a><span class="lineno">  523</span>&#160; </div>
<div class="line"><a name="l00524"></a><span class="lineno">  524</span>&#160;        ft = {</div>
<div class="line"><a name="l00525"></a><span class="lineno">  525</span>&#160;            <span class="stringliteral">&#39;Field&#39;</span>: field.name,</div>
<div class="line"><a name="l00526"></a><span class="lineno">  526</span>&#160;            <span class="stringliteral">&#39;Type&#39;</span>: field.t_type,</div>
<div class="line"><a name="l00527"></a><span class="lineno">  527</span>&#160;            <span class="stringliteral">&#39;Null&#39;</span>: field.is_null,</div>
<div class="line"><a name="l00528"></a><span class="lineno">  528</span>&#160;            <span class="stringliteral">&#39;Key&#39;</span>: field.primary_key,</div>
<div class="line"><a name="l00529"></a><span class="lineno">  529</span>&#160;            <span class="stringliteral">&#39;Default&#39;</span>: field.default,</div>
<div class="line"><a name="l00530"></a><span class="lineno">  530</span>&#160;            <span class="stringliteral">&#39;Extra&#39;</span>: field.comment,</div>
<div class="line"><a name="l00531"></a><span class="lineno">  531</span>&#160;        }</div>
<div class="line"><a name="l00532"></a><span class="lineno">  532</span>&#160; </div>
<div class="line"><a name="l00533"></a><span class="lineno">  533</span>&#160;        target = <span class="keywordtype">None</span></div>
<div class="line"><a name="l00534"></a><span class="lineno">  534</span>&#160; </div>
<div class="line"><a name="l00535"></a><span class="lineno">  535</span>&#160;        <span class="keywordflow">for</span> i <span class="keywordflow">in</span> self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#a4366cf0a58196446719143717e78d210">R</a>:</div>
<div class="line"><a name="l00536"></a><span class="lineno">  536</span>&#160;            <span class="keywordflow">if</span> field.name == i[<span class="stringliteral">&#39;Field&#39;</span>]:</div>
<div class="line"><a name="l00537"></a><span class="lineno">  537</span>&#160;                target = i</div>
<div class="line"><a name="l00538"></a><span class="lineno">  538</span>&#160;                <span class="keywordflow">break</span></div>
<div class="line"><a name="l00539"></a><span class="lineno">  539</span>&#160; </div>
<div class="line"><a name="l00540"></a><span class="lineno">  540</span>&#160;        <span class="keywordflow">if</span> target <span class="keywordflow">is</span> <span class="keywordtype">None</span>:</div>
<div class="line"><a name="l00541"></a><span class="lineno">  541</span>&#160;            <span class="keywordflow">return</span> <span class="keyword">False</span>, f<span class="stringliteral">&quot;Check failed:{ft}&quot;</span></div>
<div class="line"><a name="l00542"></a><span class="lineno">  542</span>&#160;        self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#a4366cf0a58196446719143717e78d210">R</a>.remove(target)</div>
<div class="line"><a name="l00543"></a><span class="lineno">  543</span>&#160; </div>
<div class="line"><a name="l00544"></a><span class="lineno">  544</span>&#160;        <span class="keywordflow">for</span> k, v <span class="keywordflow">in</span> ft.items():</div>
<div class="line"><a name="l00545"></a><span class="lineno">  545</span>&#160;            <span class="keywordflow">pass</span></div>
<div class="line"><a name="l00546"></a><span class="lineno">  546</span>&#160; </div>
<div class="line"><a name="l00547"></a><span class="lineno">  547</span>&#160;        <span class="keywordflow">return</span> <span class="keyword">True</span>, f<span class="stringliteral">&quot;{ft}&quot;</span></div>
<div class="line"><a name="l00548"></a><span class="lineno">  548</span>&#160; </div>
<div class="line"><a name="l00549"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#a1d69928dc72668bf99195d57ae4590e0">  549</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#a1d69928dc72668bf99195d57ae4590e0">check</a>(self):</div>
<div class="line"><a name="l00550"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#a4366cf0a58196446719143717e78d210">  550</a></span>&#160;        self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#a4366cf0a58196446719143717e78d210">R</a> = self.<a class="code" href="classaestate_1_1dbs_1_1base_1_1_opera_base.html#a2556306f9f04a15540a58c87e31818f5">instance</a>.execute_sql(f<span class="stringliteral">&quot;DESC `{self.instance.get_tb_name()}`&quot;</span>)</div>
<div class="line"><a name="l00551"></a><span class="lineno">  551</span>&#160;        <span class="keywordflow">for</span> k, v <span class="keywordflow">in</span> self.<a class="code" href="classaestate_1_1dbs_1_1base_1_1_opera_base.html#a2556306f9f04a15540a58c87e31818f5">instance</a>.getFields().items():</div>
<div class="line"><a name="l00552"></a><span class="lineno">  552</span>&#160;            f = self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#af962700fdf116f30957cb512adc334eb">extra</a>(v)</div>
<div class="line"><a name="l00553"></a><span class="lineno">  553</span>&#160;            ALog.log(f[1], obj=self, task_name=<span class="stringliteral">&quot;Check&quot;</span>) \</div>
<div class="line"><a name="l00554"></a><span class="lineno">  554</span>&#160;                <span class="keywordflow">if</span> f[0] <span class="keywordflow">else</span> \</div>
<div class="line"><a name="l00555"></a><span class="lineno">  555</span>&#160;                ALog.log_error(f[1], obj=self, task_name=<span class="stringliteral">&quot;Check&quot;</span>)</div>
<div class="line"><a name="l00556"></a><span class="lineno">  556</span>&#160; </div>
<div class="line"><a name="l00557"></a><span class="lineno">  557</span>&#160;        <span class="keywordflow">if</span> len(self.<a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#a4366cf0a58196446719143717e78d210">R</a>) != 0:</div>
<div class="line"><a name="l00558"></a><span class="lineno">  558</span>&#160;            ALog.log_error(f<span class="stringliteral">&quot;Extra field:{self.R}&quot;</span>, obj=self, task_name=<span class="stringliteral">&quot;Check&quot;</span>)</div>
<div class="line"><a name="l00559"></a><span class="lineno">  559</span>&#160; </div>
<div class="line"><a name="l00560"></a><span class="lineno"><a class="line" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#adb5f67794e28563d5f8e9373ec90d147">  560</a></span>&#160;    <span class="keyword">def </span><a class="code" href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#adb5f67794e28563d5f8e9373ec90d147">create</a>(self):</div>
<div class="line"><a name="l00561"></a><span class="lineno">  561</span>&#160;        PRIMARYKEY = <span class="keywordtype">None</span></div>
<div class="line"><a name="l00562"></a><span class="lineno">  562</span>&#160;        FIELDS = []</div>
<div class="line"><a name="l00563"></a><span class="lineno">  563</span>&#160;        default_parse = <span class="keyword">lambda</span> x: <span class="stringliteral">&quot;AUTO_INCREMENT&quot;</span> \</div>
<div class="line"><a name="l00564"></a><span class="lineno">  564</span>&#160;            <span class="keywordflow">if</span> x.autoField <span class="keywordflow">else</span> <span class="stringliteral">&#39;DEFAULT CURRENT_TIMESTAMP&#39;</span> \</div>
<div class="line"><a name="l00565"></a><span class="lineno">  565</span>&#160;            <span class="keywordflow">if</span> x.auto_time <span class="keywordflow">else</span> <span class="stringliteral">&#39;DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP&#39;</span> \</div>
<div class="line"><a name="l00566"></a><span class="lineno">  566</span>&#160;            <span class="keywordflow">if</span> x.update_auto_time <span class="keywordflow">else</span> f<span class="stringliteral">&quot;CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT &#39;{x.default}&#39;&quot;</span> \</div>
<div class="line"><a name="l00567"></a><span class="lineno">  567</span>&#160;            <span class="keywordflow">if</span> isinstance(x.default, str) <span class="keywordflow">else</span> f<span class="stringliteral">&quot;DEFAULT &#39;{x.default}&#39;&quot;</span> \</div>
<div class="line"><a name="l00568"></a><span class="lineno">  568</span>&#160;            <span class="keywordflow">if</span> isinstance(x.default, int) <span class="keywordflow">else</span> <span class="stringliteral">&quot;&quot;</span></div>
<div class="line"><a name="l00569"></a><span class="lineno">  569</span>&#160; </div>
<div class="line"><a name="l00570"></a><span class="lineno">  570</span>&#160;        type_parse = <span class="keyword">lambda</span> x: x.t_type \</div>
<div class="line"><a name="l00571"></a><span class="lineno">  571</span>&#160;            <span class="keywordflow">if</span> x.length <span class="keywordflow">is</span> <span class="keywordtype">None</span> <span class="keywordflow">else</span> <span class="stringliteral">&quot;%s(%s,%s)&quot;</span> % (x.t_type, x.length, x.d_point) \</div>
<div class="line"><a name="l00572"></a><span class="lineno">  572</span>&#160;            <span class="keywordflow">if</span> x.d_point <span class="keywordflow">is</span> <span class="keywordflow">not</span> <span class="keywordtype">None</span> <span class="keywordflow">and</span> x.length <span class="keywordflow">is</span> <span class="keywordflow">not</span> <span class="keywordtype">None</span> <span class="keywordflow">else</span> <span class="stringliteral">&quot;%s(%s)&quot;</span> % (x.t_type, x.length) \</div>
<div class="line"><a name="l00573"></a><span class="lineno">  573</span>&#160;            <span class="keywordflow">if</span> x.length <span class="keywordflow">is</span> <span class="keywordflow">not</span> <span class="keywordtype">None</span> <span class="keywordflow">else</span> x.t_type</div>
<div class="line"><a name="l00574"></a><span class="lineno">  574</span>&#160;        <span class="keywordflow">for</span> k, v <span class="keywordflow">in</span> self.<a class="code" href="classaestate_1_1dbs_1_1base_1_1_opera_base.html#a2556306f9f04a15540a58c87e31818f5">instance</a>._fields.items():</div>
<div class="line"><a name="l00575"></a><span class="lineno">  575</span>&#160;            FIELDS.append(</div>
<div class="line"><a name="l00576"></a><span class="lineno">  576</span>&#160;                <span class="stringliteral">&quot;`%s` %s %s %s,&quot;</span> %</div>
<div class="line"><a name="l00577"></a><span class="lineno">  577</span>&#160;                (</div>
<div class="line"><a name="l00578"></a><span class="lineno">  578</span>&#160;                    v.name,</div>
<div class="line"><a name="l00579"></a><span class="lineno">  579</span>&#160;                    type_parse(v),</div>
<div class="line"><a name="l00580"></a><span class="lineno">  580</span>&#160;                    default_parse(v),</div>
<div class="line"><a name="l00581"></a><span class="lineno">  581</span>&#160;                    <span class="stringliteral">&#39;NULL&#39;</span> <span class="keywordflow">if</span> v.is_null <span class="keywordflow">else</span> <span class="stringliteral">&#39;NOT NULL&#39;</span></div>
<div class="line"><a name="l00582"></a><span class="lineno">  582</span>&#160;                )</div>
<div class="line"><a name="l00583"></a><span class="lineno">  583</span>&#160;            )</div>
<div class="line"><a name="l00584"></a><span class="lineno">  584</span>&#160;            <span class="keywordflow">if</span> v.primary_key:</div>
<div class="line"><a name="l00585"></a><span class="lineno">  585</span>&#160;                PRIMARYKEY = v.name</div>
<div class="line"><a name="l00586"></a><span class="lineno">  586</span>&#160; </div>
<div class="line"><a name="l00587"></a><span class="lineno">  587</span>&#160;        sql = <span class="stringliteral">&quot;CREATE TABLE IF NOT EXISTS `%s` ( %s  %s) ENGINE=InnoDB DEFAULT CHARSET=utf8;&quot;</span> % \</div>
<div class="line"><a name="l00588"></a><span class="lineno">  588</span>&#160;              (self.<a class="code" href="classaestate_1_1dbs_1_1base_1_1_opera_base.html#a2556306f9f04a15540a58c87e31818f5">instance</a>.get_tb_name(), <span class="stringliteral">&#39;&#39;</span>.join(FIELDS), <span class="stringliteral">&quot;PRIMARY KEY (`%s`)&quot;</span> % PRIMARYKEY)</div>
<div class="line"><a name="l00589"></a><span class="lineno">  589</span>&#160; </div>
<div class="line"><a name="l00590"></a><span class="lineno">  590</span>&#160;        ALog.log(sql)</div>
<div class="line"><a name="l00591"></a><span class="lineno">  591</span>&#160;        r = self.<a class="code" href="classaestate_1_1dbs_1_1base_1_1_opera_base.html#a2556306f9f04a15540a58c87e31818f5">instance</a>.execute_sql(sql)</div>
<div class="line"><a name="l00592"></a><span class="lineno">  592</span>&#160;        <span class="keywordflow">return</span> r</div>
</div><!-- fragment --></div><!-- contents -->
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_opera_base_html_adb5f67794e28563d5f8e9373ec90d147"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#adb5f67794e28563d5f8e9373ec90d147">aestate.dbs._mysql.OperaBase.create</a></div><div class="ttdeci">def create(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00560">__init__.py:560</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a14965a4a1d4cb9299bf3f651222f4dfa"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a14965a4a1d4cb9299bf3f651222f4dfa">aestate.dbs._mysql.Fields.__new__</a></div><div class="ttdeci">def __new__(cls, *args, **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00492">__init__.py:492</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a049783a48d412908762e575970bd69e6"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a049783a48d412908762e575970bd69e6">aestate.dbs._mysql.Fields.asses_str</a></div><div class="ttdeci">def asses_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00461">__init__.py:461</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_a75311cf6ab0ef368af204b8551eeee8e"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a75311cf6ab0ef368af204b8551eeee8e">aestate.dbs._mysql.ParseUtil.insert_to_obj</a></div><div class="ttdeci">def insert_to_obj(obj, kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00345">__init__.py:345</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_a1ca5fcae7f8132f935ff3eb27448e736"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a1ca5fcae7f8132f935ff3eb27448e736">aestate.dbs._mysql.ParseUtil.fieldExist</a></div><div class="ttdeci">object fieldExist(object obj, str field, el=None, raise_exception=False)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00306">__init__.py:306</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a7133146198a939dc7c5f5f38511387c5"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a7133146198a939dc7c5f5f38511387c5">aestate.dbs._mysql.Fields.desc_str</a></div><div class="ttdeci">def desc_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00433">__init__.py:433</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_ae85305a9679051b479d80303b7a9b103"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ae85305a9679051b479d80303b7a9b103">aestate.dbs._mysql.ParseUtil.parse_key</a></div><div class="ttdeci">def parse_key(self, *args, **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00053">__init__.py:53</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a08bf7945554d7e2627f961b09ab7c3f6"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a08bf7945554d7e2627f961b09ab7c3f6">aestate.dbs._mysql.Fields.where_str</a></div><div class="ttdeci">def where_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00417">__init__.py:417</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a9aa2757979eb6d85b78d0c6ac52b79c9"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a9aa2757979eb6d85b78d0c6ac52b79c9">aestate.dbs._mysql.Fields.left_par</a></div><div class="ttdeci">def left_par(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00465">__init__.py:465</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a2dde140ca287b970b0befe8fde431b06"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a2dde140ca287b970b0befe8fde431b06">aestate.dbs._mysql.Fields.limit_str</a></div><div class="ttdeci">def limit_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00445">__init__.py:445</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_opera_base_html_a4366cf0a58196446719143717e78d210"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#a4366cf0a58196446719143717e78d210">aestate.dbs._mysql.OperaBase.R</a></div><div class="ttdeci">R</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00550">__init__.py:550</a></div></div>
<div class="ttc" id="anamespaceaestate_1_1dbs_1_1__mysql_html"><div class="ttname"><a href="namespaceaestate_1_1dbs_1_1__mysql.html">aestate.dbs._mysql</a></div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00001">__init__.py:1</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html">aestate.dbs._mysql.ParseUtil</a></div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00015">__init__.py:15</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a5f1f67a3fe6e4c06dd7051ea8a320bbf"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a5f1f67a3fe6e4c06dd7051ea8a320bbf">aestate.dbs._mysql.Fields.find_str</a></div><div class="ttdeci">def find_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00413">__init__.py:413</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_afb3b666e0b3ab89d946dc04597c9ce58"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#afb3b666e0b3ab89d946dc04597c9ce58">aestate.dbs._mysql.ParseUtil.find_print_sql</a></div><div class="ttdeci">def find_print_sql(**kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00227">__init__.py:227</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1tag_1_1_template_html"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1tag_1_1_template.html">aestate.dbs._mysql.tag.Template</a></div><div class="ttdef"><b>Definition:</b> <a href="tag_8py_source.html#l00091">tag.py:91</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_a5615e77e77754c370e71054b3e45d4eb"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a5615e77e77754c370e71054b3e45d4eb">aestate.dbs._mysql.ParseUtil.parse_update</a></div><div class="ttdeci">def parse_update(self, pojo, key)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00068">__init__.py:68</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a6b4970ec555be4a06ed5c7e2c263efe4"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a6b4970ec555be4a06ed5c7e2c263efe4">aestate.dbs._mysql.Fields.group_by_str</a></div><div class="ttdeci">def group_by_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00429">__init__.py:429</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_adf50b29089db27341b0bf4b9b8a95016"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#adf50b29089db27341b0bf4b9b8a95016">aestate.dbs._mysql.ParseUtil.case_name</a></div><div class="ttdeci">def case_name(text, rep_text='_', lower=True, upper=False)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00249">__init__.py:249</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a7493eea273580951f8ce1a2fe73a3f30"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a7493eea273580951f8ce1a2fe73a3f30">aestate.dbs._mysql.Fields.set_str</a></div><div class="ttdeci">def set_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00437">__init__.py:437</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1tag_1_1base_tag_html"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1tag_1_1base_tag.html">aestate.dbs._mysql.tag.baseTag</a></div><div class="ttdef"><b>Definition:</b> <a href="tag_8py_source.html#l00010">tag.py:10</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_ac8360186b23df53ce7366fe68b33c6b7"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ac8360186b23df53ce7366fe68b33c6b7">aestate.dbs._mysql.Fields.eq</a></div><div class="ttdeci">def eq(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00477">__init__.py:477</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a9e58cd803affd57b482ee7ee20425ad7"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a9e58cd803affd57b482ee7ee20425ad7">aestate.dbs._mysql.Fields.symbol</a></div><div class="ttdeci">def symbol(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00489">__init__.py:489</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_a49c91d241a0f90a594b767b79f4747ff"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a49c91d241a0f90a594b767b79f4747ff">aestate.dbs._mysql.ParseUtil.parse_remove</a></div><div class="ttdeci">def parse_remove(self, pojo, key)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00087">__init__.py:87</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a330bc1d69ac87922e2ed0c564ce71fce"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a330bc1d69ac87922e2ed0c564ce71fce">aestate.dbs._mysql.Fields.on_str</a></div><div class="ttdeci">def on_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00481">__init__.py:481</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_afa5e92496e2f008ba6fd47e61ee3cae1"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#afa5e92496e2f008ba6fd47e61ee3cae1">aestate.dbs._mysql.Fields.left_join_str</a></div><div class="ttdeci">def left_join_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00485">__init__.py:485</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_opera_base_html_a1d69928dc72668bf99195d57ae4590e0"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#a1d69928dc72668bf99195d57ae4590e0">aestate.dbs._mysql.OperaBase.check</a></div><div class="ttdeci">def check(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00549">__init__.py:549</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a52d2b02229ebf64b80de220d5739785a"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a52d2b02229ebf64b80de220d5739785a">aestate.dbs._mysql.Fields.right_subscript</a></div><div class="ttdeci">def right_subscript(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00385">__init__.py:385</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html">aestate.dbs._mysql.Fields</a></div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00359">__init__.py:359</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_ace50f38bba3c639dd0fdbac7a91dd3f4"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ace50f38bba3c639dd0fdbac7a91dd3f4">aestate.dbs._mysql.ParseUtil.parse_pojo_many</a></div><div class="ttdeci">List[tuple] parse_pojo_many(list pojo_many)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00334">__init__.py:334</a></div></div>
<div class="ttc" id="anamespaceaestate_1_1util_html"><div class="ttname"><a href="namespaceaestate_1_1util.html">aestate.util</a></div><div class="ttdef"><b>Definition:</b> <a href="util_2____init_____8py_source.html#l00001">__init__.py:1</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a2a2de8a1b2c0be73a7c0e09b3d22dbf3"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a2a2de8a1b2c0be73a7c0e09b3d22dbf3">aestate.dbs._mysql.Fields.order_by_str</a></div><div class="ttdeci">def order_by_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00425">__init__.py:425</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a39d43d7c7146306472dcf68a1d567711"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a39d43d7c7146306472dcf68a1d567711">aestate.dbs._mysql.Fields.space</a></div><div class="ttdeci">def space(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00378">__init__.py:378</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_ae8f0cf30f05102843b8e2d25c85e5c1d"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ae8f0cf30f05102843b8e2d25c85e5c1d">aestate.dbs._mysql.ParseUtil.parse_pojo</a></div><div class="ttdeci">Tuple[list, list] parse_pojo(pojo)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00165">__init__.py:165</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_a1a040266609abb01fcbb3a47527283cf"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a1a040266609abb01fcbb3a47527283cf">aestate.dbs._mysql.ParseUtil.set_field</a></div><div class="ttdeci">def set_field(obj, key, value)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00283">__init__.py:283</a></div></div>
<div class="ttc" id="anamespaceaestate_1_1util_1_1_log_html"><div class="ttname"><a href="namespaceaestate_1_1util_1_1_log.html">aestate.util.Log</a></div><div class="ttdef"><b>Definition:</b> <a href="_log_8py_source.html#l00001">Log.py:1</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_a17ed4dfab84ad61174e1edb9969ea2ec"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a17ed4dfab84ad61174e1edb9969ea2ec">aestate.dbs._mysql.ParseUtil.parse_obj</a></div><div class="ttdeci">object parse_obj(dict data, object instance)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00180">__init__.py:180</a></div></div>
<div class="ttc" id="anamespaceaestate_1_1work_1_1_modes_html"><div class="ttname"><a href="namespaceaestate_1_1work_1_1_modes.html">aestate.work.Modes</a></div><div class="ttdef"><b>Definition:</b> <a href="_modes_8py_source.html#l00001">Modes.py:1</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a9cd9e8b40f0851764e691449a67e06ce"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a9cd9e8b40f0851764e691449a67e06ce">aestate.dbs._mysql.Fields.update_str</a></div><div class="ttdeci">def update_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00406">__init__.py:406</a></div></div>
<div class="ttc" id="anamespaceaestate_1_1exception_html"><div class="ttname"><a href="namespaceaestate_1_1exception.html">aestate.exception</a></div><div class="ttdef"><b>Definition:</b> <a href="exception_2____init_____8py_source.html#l00001">__init__.py:1</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_ac9c4c272f28e485c7bd9630c98094687"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ac9c4c272f28e485c7bd9630c98094687">aestate.dbs._mysql.Fields.comma</a></div><div class="ttdeci">def comma(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00473">__init__.py:473</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_ab6ceb33d4f9ca3ea8e5244c420623dab"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab6ceb33d4f9ca3ea8e5244c420623dab">aestate.dbs._mysql.Fields.by_str</a></div><div class="ttdeci">def by_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00421">__init__.py:421</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_ae0d8e6fa65b38eed4dd4b6ba93a56c9e"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ae0d8e6fa65b38eed4dd4b6ba93a56c9e">aestate.dbs._mysql.ParseUtil.parse_insert_pojo</a></div><div class="ttdeci">def parse_insert_pojo(self, pojo, __table_name__, insert_str, values_str)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00138">__init__.py:138</a></div></div>
<div class="ttc" id="anamespaceaestate_1_1dbs_html"><div class="ttname"><a href="namespaceaestate_1_1dbs.html">aestate.dbs</a></div><div class="ttdef"><b>Definition:</b> <a href="dbs_2____init_____8py_source.html#l00001">__init__.py:1</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_a1659491b4d75d4ce96540f02bc2bea73"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a1659491b4d75d4ce96540f02bc2bea73">aestate.dbs._mysql.ParseUtil.parse_main</a></div><div class="ttdeci">def parse_main(self, *args, to_str=False, symbol='%s', left='`', right='`', **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00017">__init__.py:17</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_a734ed2fd0f46ed39ff94bf41237005eb"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a734ed2fd0f46ed39ff94bf41237005eb">aestate.dbs._mysql.ParseUtil.get_pojo_sql</a></div><div class="ttdeci">def get_pojo_sql(self, instance)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00349">__init__.py:349</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_ae1f4802c6dc78179f0b2fbad4a72739f"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ae1f4802c6dc78179f0b2fbad4a72739f">aestate.dbs._mysql.ParseUtil.is_default</a></div><div class="ttdeci">def is_default(__val)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00271">__init__.py:271</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_afb883f03c0e5b31b7e8a10e7a04424de"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#afb883f03c0e5b31b7e8a10e7a04424de">aestate.dbs._mysql.Fields.delete_str</a></div><div class="ttdeci">def delete_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00399">__init__.py:399</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a3b8872efa64705ca6bca58bcee6d6b45"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a3b8872efa64705ca6bca58bcee6d6b45">aestate.dbs._mysql.Fields.values_str</a></div><div class="ttdeci">def values_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00457">__init__.py:457</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_ab2a945c3930242848b9faf5f08e7fb87"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ab2a945c3930242848b9faf5f08e7fb87">aestate.dbs._mysql.Fields.parse_field</a></div><div class="ttdeci">str parse_field(str key)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00367">__init__.py:367</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_a3f318bacc1a79c2a0ea5810a1e07df52"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#a3f318bacc1a79c2a0ea5810a1e07df52">aestate.dbs._mysql.ParseUtil.set_field_compulsory</a></div><div class="ttdeci">None set_field_compulsory(obj, str key, dict data, object val)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00296">__init__.py:296</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_aa954b7c6dc8ec5be45afadaf96c782d1"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#aa954b7c6dc8ec5be45afadaf96c782d1">aestate.dbs._mysql.Fields.left_subscript</a></div><div class="ttdeci">def left_subscript(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00371">__init__.py:371</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_opera_base_html"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html">aestate.dbs._mysql.OperaBase</a></div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00497">__init__.py:497</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_opera_base_html_af962700fdf116f30957cb512adc334eb"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_opera_base.html#af962700fdf116f30957cb512adc334eb">aestate.dbs._mysql.OperaBase.extra</a></div><div class="ttdeci">Tuple[bool, object] extra(self, field)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00499">__init__.py:499</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_ae5a69b48039b53489a1fb72588482719"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#ae5a69b48039b53489a1fb72588482719">aestate.dbs._mysql.Fields.insert_str</a></div><div class="ttdeci">def insert_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00392">__init__.py:392</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a0d58b3c09dc14f73832ded52e921e81b"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a0d58b3c09dc14f73832ded52e921e81b">aestate.dbs._mysql.Fields.ander_str</a></div><div class="ttdeci">def ander_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00441">__init__.py:441</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1base_1_1_opera_base_html_a2556306f9f04a15540a58c87e31818f5"><div class="ttname"><a href="classaestate_1_1dbs_1_1base_1_1_opera_base.html#a2556306f9f04a15540a58c87e31818f5">aestate.dbs.base.OperaBase.instance</a></div><div class="ttdeci">instance</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2base_8py_source.html#l00006">base.py:6</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_afaa381afb53a5a0b9f3e01cd286c299a"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#afaa381afb53a5a0b9f3e01cd286c299a">aestate.dbs._mysql.ParseUtil.parse_insert</a></div><div class="ttdeci">def parse_insert(self, keys, values, __table_name__, insert_str, values_str, symbol='%s', sql_format='%s %s(%s)%s(%s)')</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00106">__init__.py:106</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a5c1ec1013eb32813d9960e8d843fbe4e"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a5c1ec1013eb32813d9960e8d843fbe4e">aestate.dbs._mysql.Fields.value_str</a></div><div class="ttdeci">def value_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00453">__init__.py:453</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_aa2923ad8dc9fc2e274bc29674f5e01ac"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#aa2923ad8dc9fc2e274bc29674f5e01ac">aestate.dbs._mysql.ParseUtil.find_last_id</a></div><div class="ttdeci">def find_last_id(**kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00196">__init__.py:196</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_parse_util_html_ac3b4dd4b502ce4e358ad1ed77988383b"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_parse_util.html#ac3b4dd4b502ce4e358ad1ed77988383b">aestate.dbs._mysql.ParseUtil.parse_value</a></div><div class="ttdeci">def parse_value(self, *args, **kwargs)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00096">__init__.py:96</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a4367ca8070595df3332a4b48b8af926c"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a4367ca8070595df3332a4b48b8af926c">aestate.dbs._mysql.Fields.from_str</a></div><div class="ttdeci">def from_str(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00449">__init__.py:449</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1base_1_1_opera_base_html"><div class="ttname"><a href="classaestate_1_1dbs_1_1base_1_1_opera_base.html">aestate.dbs.base.OperaBase</a></div><div class="ttdef"><b>Definition:</b> <a href="dbs_2base_8py_source.html#l00004">base.py:4</a></div></div>
<div class="ttc" id="aclassaestate_1_1dbs_1_1__mysql_1_1_fields_html_a9acc2223fb8aee96870aac942b1a8796"><div class="ttname"><a href="classaestate_1_1dbs_1_1__mysql_1_1_fields.html#a9acc2223fb8aee96870aac942b1a8796">aestate.dbs._mysql.Fields.right_par</a></div><div class="ttdeci">def right_par(self)</div><div class="ttdef"><b>Definition:</b> <a href="dbs_2__mysql_2____init_____8py_source.html#l00469">__init__.py:469</a></div></div>
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Generated by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.8.17
</small></address>
</body>
</html>
